package com.bdqn.oa.dao;

import com.bdqn.oa.entity.Work;

import java.sql.SQLException;
import java.util.List;

/**
 * @author qiaolu
 * @date 2022/7/20 15:24
 */
public interface WorkDao {
    /**
     * 通过workid查询
     * @return
     * @throws SQLException
     */
    public Work getbyidWork(Integer workid)throws SQLException;

    /**
     * 查询全部工作
     * @return
     * @throws SQLException
     */
    public List<Work>listAllWorky()throws SQLException;
    /**
     * 增加工作
     * @return
     * @throws SQLException
     */
    public int saveWork(Work work)throws SQLException;

    /**
     * 修改工作
     * @return
     * @throws SQLException
     */
    public int updateWork(Work work)throws SQLException;

}
